home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Amiga Plus 1997 #1
/
Amiga Plus CD - 1997 - No. 01.iso
/
pd
/
daten
/
easycalc
/
examples
/
strings.calc
(
.txt
)
< prev
next >
Wrap
EasyCalc Spreadsheet file
|
1986-06-08
|
1KB
|
45 lines
EASY30HED1
#'EasyCalc 2.0 - Example Worksheet 1
'String Functions
'Function Example
"Result
'=@CHR(65)
=@CHR(65)
'=@COMPARE("A","B")
=@COMPARE("A","B")
'=@FIND("FREDDIE","RED",1)
=@FIND("FREDDIE","RED",1)
'=@INSTR("FREDDIE","red")
=@INSTR("FREDDIE","red")
'=@LEFT("FRED",2)
=@LEFT("FRED",2)
'=@LENGTH("freddie")
=@LENGTH("freddie")
'=@LOWER("FREDDIE")
=@LOWER("FREDDIE")
'=@MID("freddie",2,3)
=@MID("freddie",2,3)
'=@PROPER("mr freddie jones")
=@PROPER("mr freddie jones")
'=@REPEAT("fred ",4)
=@REPEAT("fred ",4)
'=@RIGHT("fred",2)
=@RIGHT("fred",2)
'=@STR(56.7)
=@STR(56.7)
'=@VAL("56.7")
=@VAL("56.7")
'=@UPPER("freddie")
=@UPPER("freddie")
D'New for EasyCalc 2.0, you can now compare and add strings together:
'="A" = "B"
="A" = "B"
'="A" <> "B"
="A" <> "B"
'="A" + "B"
="A"+"B"
'="A" > "B"
="A" > "B"
'="A" < "B"
="A" < "B"